-- created by kumiler
-- on 2022/11/28 17:25
-- DESC
create external table jms_dwd.dwd_tab_report_errorbagging_detail_base_dt
(
    scan_time        timestamp comment '扫描时间',
    site_code        string comment '网点编号',
    site_name        string comment '网点名称',
    proxy_area_code  string comment '代理区编号',
    proxy_area_name  string comment '代理区名称',
    franchisees_code string comment '加盟商编号',
    franchisees_name string comment '加盟商名称',
    bagc_ode         string comment '包号',
    bill_code        string comment '单号',
    shouldodm        string comment '应建包一段码',
    realodm          string comment '实际建包一段码',
    scan_user_code   string comment '扫描员编码',
    scan_user_name   string comment '扫描员名称',
    bill_source      string comment '运单来源',
    remark2          string comment '备注2',
    create_time      timestamp comment '创建时间'
)
    comment '建包错误表'
    partitioned by (dt string comment '扫描时间scan_time(yyyy-mm-dd)')
    stored as parquet
    location '/dw/hive/jms_dwd.db/external/dwd_tab_report_errorbagging_detail_base_dt'
;